After an execution plan is generated , it stays in the procedure cache 生成执行计划后,它处于过程缓存中。
Number of pages in the procedure cache that are currently allocated to this process 当前为此进程分配的过程缓存中的页数。
The lazywriter process periodically scans the list of objects in the procedure cache 惰性写入器进程定期扫描过程缓存中的对象列表。
The part of the memory pool that is used to store execution plans is referred to as the procedure cache 内存池中用于存储执行计划的部分称为过程缓存。
The age of our sample query plan is decremented to 0 after 16 scans of the procedure cache , unless another user references the plan 在本例中,查询计划的年经过16次过程缓存扫描后减为0 ,除非其他用户引用了该计划。
If there are any execution plans in the procedure cache that reference the table , alter table marks them to be recompiled on their next execution 如果过程缓存中存在引用表的执行计划, alter table会将这些执行计划标记为下次执行时重新编译。
When any sql statement is executed in sql server 2005 , the relational engine first looks through the procedure cache to verify that an existing execution plan for the same sql statement exists 在sql server 2005中执行任何sql语句时,关系引擎将首先查看过程缓存中是否有用于同一sql语句的现有执行计划。